package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundIndexGroup({
        @_DDL_CompoundIndex(name = "idx_query", columns = {"TRANS_TYPE", "TRANS_STATUS"})
})
@_DDL_Table(name = "aqb_recharge_withdraw", simpleName = "", engine = MysqlDriver.InnoDB, comment = "AQB账号充值提现记录")
public class _DDL_AqbRechargeWithdraw {

    @_DDL_Primary()
    @_DDL_Column(name = "MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "商户订单号")
    private String merOrderNo;

    @_DDL_Index(name = "idx_qw_usr")
    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "BASE_ACC_TYPE", type = SqlType.INT, nullable = false, comment = "基础账号类型，1：平安、2：内部户")
    private Integer baseAccType;

    @_DDL_Column(name = "TRANS_ROLE", type = SqlType.INT, nullable = false, comment = "交易角色，0：用户、1：系统、2：人工")
    private Integer transRole;

    @_DDL_Column(name = "TRANS_TYPE", type = SqlType.INT, nullable = false, comment = "交易类型，0：充值、1：提现")
    private Integer transType;

    @_DDL_Column(name = "ACC_TYPE", type = SqlType.INT, nullable = false, comment = "账号类型，0：余额账号、1：保证金账号")
    private Integer accType;

    @_DDL_Column(name = "CARD_NO", type = SqlType.VARCHAR, size = 50, comment = "易通卡卡号")
    private String cardNo;

    @_DDL_Column(name = "BIND_ACCT_NO", type = SqlType.VARCHAR, size = 30, comment = "一类银行卡")
    private String bindAcctNo;

    @_DDL_Column(name = "AQB_ACCT_NO", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "AQB账号")
    private String aqbAcctNo;

    @_DDL_Column(name = "TRANS_AMT", type = SqlType.VARCHAR, size = 15, nullable = false, comment = "交易金额")
    private String transAmt;

    @_DDL_Column(name = "DK_AMT", type = SqlType.VARCHAR, size = 15, comment = "银行卡代扣金额")
    private String dkAmt;

    @_DDL_Column(name = "HQ_AMT", type = SqlType.VARCHAR, size = 15, comment = "三类户扣款金额")
    private String hqAmt;

    @_DDL_Column(name = "TRANS_SERIAL_NO", type = SqlType.VARCHAR, size = 60, comment = "交易流水号")
    private String transSerialNo;

    @_DDL_Column(name = "TRANS_TIME", type = SqlType.VARCHAR, size = 20, comment = "交易时间")
    private String transTime;

    @_DDL_Column(name = "TRANS_STATUS", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "交易状态，init：初始、fail：失败、succ：成功、unknow：未知")
    private String transStatus;

    @_DDL_Column(name = "ERROR_CODE", type = SqlType.VARCHAR, size = 30, comment = "错误码")
    private String errorCode;

    @_DDL_Column(name = "ERROR_MSG", type = SqlType.VARCHAR, size = 1000, comment = "错误信息")
    private String errorMsg;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "创建时间")
    private String createTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "更新时间")
    private String updateTime;

    @_DDL_Column(name = "BIND_ACCT_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "一类银行卡密文")
    private String bindAcctNoCiphertext;

}
